Expert @ Excel VBA Programming: A Step-By-Step Guide To Learn And Master Excel VBA Programming To Get Ahead @ Work, Business And Personal Finances by Reed Daniel & Reed Daniel

Author:Reed, Daniel & Reed, Daniel [Reed, Daniel]
Language: eng
Format: epub
Published: 2018-10-21T16:00:00+00:00

Using Boolean Values to Make Decisions

The Boolean type is the easiest to use and understand. This type is used to indicate yes or no, true or false and on or off. You can use this type to work with any two-state information. This operator is used to represent data variables and values that are diametrically opposed.

Working with Operators

Operators determine how VBA works with two variables and what result it produces. The examples in this chapter use operators to add numbers and concatenate (add) strings. In both cases, your code uses the + operator to perform the task; however, the result differs. When you are using numbers, the result is a summation, such as 1 + 2 = 3. When you are using strings, the result is a concatenation, such as Hello + World = Hello World.

VBA groups operators into four areas:

Arithmetic : Operators that perform math operations, such as addition (+), subtraction (-), division (/), and multiplication (*).

Comparison : Operators such as less than (<), greater than (>), and equal (=) that compare two values and produce a Boolean result.

Concatenation : Operators such as & and + that are used to add two strings together.

Logical : Operators such as Not, And, Or, and Xor that are used to perform Boolean operations on two variables.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.